So the procedure processing the logic has an outermost check that will decide whether the rest of the body will execute or the procedure returns with no action taken.
因此,处理该逻辑的过程有一个最外层的检查,决定是执行主体的其余部分,还是不采取任何动作而返回。
Solution: Check the CREATE PROCEDURE statement and make sure you are passing the correct number of input and output parameters with proper data types.
解决方案: 检查 CREATE PROCEDURE 语句,确保传递的输入和输出参数的数量和数据类型都正确。
Note that the tuned procedure does not fail if the precondition is not checked outside, since the check is repeated in the body of the procedure.
注意,已调优的过程就不会因为没有在外部检查先决条件而失败,因为过程体中会重复这个检查。
The format is the same. I'm going to ask for some input, and then I am going to use that procedure to check, is this the right type of value. And I'm trying to use that to do the coercion if you like. Same thing if it works, I'm going to skip that, if it not, it's going to throw the exception.
格式是一样的,我需要一些输入,然后我要用一个过程来检查,是否是正确的值,然后你就可以做强制转换了,如果能运行,那是一样的,我打算跳过这段,如果不正确,那就会抛出一个异常。
应用推荐